package com.teach.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.teach.dto.UserSearch;
import com.teach.entity.UserInfo;

public interface UserInfoMapper {
    int deleteByPrimaryKey(String userName);

    int insert(UserInfo record);

    int insertSelective(UserInfo record);

    UserInfo selectByPrimaryKey(String userName);
    
    @Select("select * from user_info where USER_TEL=#{userTel}")
    UserInfo selectByUserTel(@Param("userTel") String userTel);

    int updateByPrimaryKeySelective(UserInfo record);

    int updateByPrimaryKey(UserInfo record);
    
    List<UserInfo> select(UserSearch search);
    
    @Select("select * from user_info")
    List<UserInfo> selectAll();
}